/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 80025
 Source Host           : localhost:3306
 Source Schema         : video

 Target Server Type    : MySQL
 Target Server Version : 80025
 File Encoding         : 65001

 Date: 2/05/2024 18:26:35
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for enjoy_collection
-- ----------------------------
DROP TABLE IF EXISTS `enjoy_collection`;
CREATE TABLE `enjoy_collection`  (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `video_id` bigint(10) NULL DEFAULT NULL COMMENT '视频id',
  `user_id` bigint(10) NULL DEFAULT NULL COMMENT '用户id',
  `click` int(10) NULL DEFAULT 0 COMMENT '点赞数量',
  `store` int(1) NULL DEFAULT 0 COMMENT '收藏标志1:收藏 0:未收藏',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of enjoy_collection
-- ----------------------------
BEGIN;
INSERT INTO `enjoy_collection` VALUES (25, 16, 5, 1, 1, '2022-05-12 18:06:14'), (26, 16, 4, 0, 1, '2022-05-12 18:07:11');
COMMIT;

-- ----------------------------
-- Table structure for evaluation
-- ----------------------------
DROP TABLE IF EXISTS `evaluation`;
CREATE TABLE `evaluation`  (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `video_id` bigint(10) NULL DEFAULT NULL COMMENT '视频id',
  `comment` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '评论',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `user_id` bigint(10) NULL DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of evaluation
-- ----------------------------
BEGIN;
INSERT INTO `evaluation` VALUES (8, 16, '漂亮', '2022-05-12 18:06:05', 5), (9, 16, '完美', '2022-05-12 18:07:19', 4);
COMMIT;

-- ----------------------------
-- Table structure for information
-- ----------------------------
DROP TABLE IF EXISTS `information`;
CREATE TABLE `information`  (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '咨询标题',
  `content` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '咨询内容',
  `url` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '图片url',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of information
-- ----------------------------
BEGIN;
INSERT INTO `information` VALUES (4, '咨询1', 'www.baidu.com', 'http://192.168.0.102:8085/download?fileName=bab33ff3-e634-495c-8174-b8fe10aaf866.jpg', '2022-05-12 18:05:43'), (5, '咨询2', 'www.baidu.com', 'http://192.168.0.102:8085/download?fileName=509e4605-f6e8-4eff-a721-f598f272ac79.jpg', '2022-05-12 18:23:09');
COMMIT;

-- ----------------------------
-- Table structure for user_info
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info`  (
  `id` bigint(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户名称',
  `password` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户密码',
  `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '手机号',
  `type` int(1) NULL DEFAULT 2 COMMENT '类型1 管理员  2普通用户',
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of user_info
-- ----------------------------
BEGIN;
INSERT INTO `user_info` VALUES (1, '1', '1', '1', 1, '2022-05-04 15:49:11'), (3, NULL, '4', '4', 2, '2022-05-04 16:39:31'), (4, NULL, '5', '5', 2, '2022-05-04 16:39:31'), (5, NULL, '3', '3', 2, '2022-05-11 16:05:26');
COMMIT;

-- ----------------------------
-- Table structure for video
-- ----------------------------
DROP TABLE IF EXISTS `video`;
CREATE TABLE `video`  (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '视频标题',
  `content` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '视频内容',
  `url` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '视频url',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `type` int(1) NULL DEFAULT NULL COMMENT '1生活 2 动漫  3漫画  4小说   5番剧  6预告PV  7OP   8ED',
  `c_total` int(10) NULL DEFAULT 0 COMMENT '点赞总数',
  `s_total` int(10) NULL DEFAULT 0 COMMENT '收藏总数',
  `p_total` int(10) NULL DEFAULT 0 COMMENT '评论总数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of video
-- ----------------------------
BEGIN;
INSERT INTO `video` VALUES (16, '视频1', '考研', 'http://192.168.0.102:8085/download?fileName=35d62ba6-1039-408f-b4ae-7d7fa4b94319.mp4', '2022-05-12 18:04:58', 1, 1, 2, 2), (17, '视频2', 'IT', 'http://192.168.0.102:8085/download?fileName=030e7193-3864-426f-9906-831b4fc00fe1.mp4', '2022-05-12 18:05:19', 2, 0, 0, 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
